Creating Drill Through Information Buttons 24

Next, we will set up the drill through information buttons.


Step 1:  Create a Drill Through Information Button on Dashboard 01

In Power BI Desktop, click on the page, RaleighPoliceIncidents


Click Insert tab ->  Buttons and select Information


Visualizations

Click the Information  icon


Fields

N/A



Visualizations


Under Visualizations ->  General: X Position = 1233 , Y Position = 0 , Width = 167 , Height = 108

Under Visualizations -> Button Text ->  Set it to OFF

Under Visualizations -> Icon ->  Set it to ON = Default State  , Information , Padding = 4 , Vertical Alignment = Center , Horizontal Alignment = Center , Line Color = 000000 , Weight = 5 pt

Under Visualizations -> Title ->  Set it to ON , Title Text = Drill Through 1 of 3 , Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 16 pt , Font Family = DIN (Default)

Under Visualizations ->  Background ->  Set it to ON , Color = FFF

Under Visualizations ->  Border ->  Set it to ON , Color = 666666

Under Visualizations ->  Action -> Type = Drill Through , Destination = RaleighPoliceIncidents-District


Step 2:  Create a Drill Through Information Button on Dashboard 02

Click on the 'Drill Through 1 of 3' from Dashboard 01 , press Ctrl+C to copy and Ctrl+V to paste it the 2nd Dashboard page, RaleighPoliceIncidents-District

From the copied 'Drill Through 1 of 3' from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:



Visualizations

Under Visualizations ->  General: X Position = 1195 , Y Position = 0 , Width = 205 , Height = 108

Under Visualizations -> Button Text ->  Set it to OFF

Under Visualizations -> Icon ->  Set it to ON = Default State  , Information , Padding = 4 , Vertical Alignment = Center , Horizontal Alignment = Center , Line Color = 000000 , Weight = 5 pt

Under Visualizations -> Title ->  Set it to ON , Title Text = Drill Through 2 of 3 , Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 16 pt , Font Family = DIN (Default)

Under Visualizations ->  Background ->  Set it to ON , Color = FFF

Under Visualizations ->  Border ->  Set it to ON , Color = 666666

Under Visualizations ->  Action -> Type = Drill Through , Destination = RaleighPoliceIncidents-Street


Step 3:  Create a Drill Through Information Button on Dashboard 03

Click on the 'Drill Through 1 of 3' from Dashboard 01 , press Ctrl+C to copy and Ctrl+V to paste it the 3rd Dashboard page, RaleighPoliceIncidents-District

From the copied 'Drill Through 1 of 3' from Dashboard 01, RaleighPoliceIncidents, to this dashboard, set up as follows:



Visualizations

Under Visualizations ->  General: X Position = 1195 , Y Position = 0 , Width = 205 , Height = 120

Under Visualizations -> Button Text ->  Set it to OFF

Under Visualizations -> Icon ->  Set it to ON = Default State  , Information , Padding = 4 , Vertical Alignment = Center , Horizontal Alignment = Center , Line Color = 000000 , Weight = 5 pt

Under Visualizations -> Title ->  Set it to ON , Title Text = Drill Through 3 of 3 , Font Color = 094780 , Background Color = E6E6E6 , Alignment = Center , Text Size = 16 pt , Font Family = DIN (Default)

Under Visualizations ->  Background ->  Set it to ON , Color = FFF

Under Visualizations ->  Border ->  Set it to ON , Color = 666666

Under Visualizations ->  Action -> Set it to OFF




When finished, save project.


How to Set up drill through in Power BI reports